409
|
How can I display a different caption in the label area

With AxComboBox1
.BeginUpdate()
.Style = EXCOMBOBOXLib.StyleEnum.DropDownList
.IntegralHeight = True
.HeaderVisible = False
.SingleEdit = True
.SearchColumnIndex = -1
.AdjustSearchColumn = False
.Columns.Add("Language").Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
With .Items
.AddItem("English")
.AddItem("Hebrew")
.AddItem("Spanish")
End With
.LabelText = " <b>custom</b> text "
.EndUpdate()
End With
|
160
|
How can I display a custom size picture to a cell or item

With AxComboBox1
.DefaultItemHeight = 48
.Columns.Add("C1")
With .Items
.CellPicture(.AddItem("Text"),0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
End With
End With
|
210
|
How can I display a computed column and highlight some values that are negative or less than a value

Dim var_ConditionalFormat
With AxComboBox1
.Columns.Add("A")
.Columns.Add("B")
.Columns.Add("(A+B)*1.19").ComputedField = "(%0 + %1) * 1.19"
With .Items
.CellCaption(.AddItem(1),1) = 2
End With
With .Items
.CellCaption(.AddItem(10),1) = 20
End With
var_ConditionalFormat = .ConditionalFormats.Add("%2 > 10")
With var_ConditionalFormat
.Bold = True
.ForeColor = RGB(255,0,0)
.ApplyTo = &H2
End With
End With
|
276
|
How can I display a button inside the item or cell

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = " Button 1 "
.CellHAlignment(h,1) = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.CellHasButton(h,1) = True
h = .AddItem("Cell 2")
.CellCaption(h,1) = " Button 2 "
.CellHAlignment(h,1) = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
.CellHasButton(h,1) = True
End With
End With
|
203
|
How can I customize the items being displayed in the drop down filter window

With AxComboBox1
With .Columns.Add("Custom Filter")
.DisplayFilterButton = True
.DisplayFilterPattern = False
.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*." & _
"txt|*.log"
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exPattern
.Filter = "*.xls"
End With
.Items.AddItem("excel.xls")
.Items.AddItem("word.doc")
.Items.AddItem("pp.pps")
.Items.AddItem("text.txt")
.ApplyFilter()
End With
|
549
|
How can I create a new ADO recordset

Dim rs
With AxComboBox1
.BeginUpdate()
rs = CreateObject("ADODB.Recordset")
With rs
.Fields.Append("A",8)
.Fields.Append("B",8)
.Open()
.AddNew()
.Fields.Item("A").Value = "Item A.1"
.Fields.Item("B").Value = "Item B.1"
.Update()
.AddNew()
.Fields.Item("A").Value = "Item A.2"
.Fields.Item("B").Value = "Item B.2"
.Update()
End With
.DataSource = rs
.Value = "Item A.1"
.EndUpdate()
End With
|
372
|
How can I convert the expression to a string so I can look into the date string expression for month's name

With AxComboBox1
.Columns.Add("Number")
.Columns.Add("Str").ComputedField = "str(%0) + ' AA'"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
427
|
How can I collapse all items

Dim h
With AxComboBox1
.BeginUpdate()
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Items")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,Nothing,"Child 1")
.InsertItem(h,Nothing,"Child 2")
h = .AddItem("Root 2")
.InsertItem(h,Nothing,"Child 1")
.InsertItem(h,Nothing,"Child 2")
.ExpandItem(0) = False
End With
.EndUpdate()
End With
|
340
|
How can I close the drop down window when user double clicks it

Dim h
With AxComboBox1
.CloseOnDblClk = True
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.CellCaption(h,1) = "Root 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
.ExpandItem(h) = True
h = .AddItem("Root 2.1")
.CellCaption(h,1) = "Root 2.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
End With
End With
|
384
|
How can I check the hour part only so I know it was afternoon

With AxComboBox1
.ConditionalFormats.Add("hour(%0)>=12").Bold = True
.Columns.Add("Date")
.Columns.Add("Hour").ComputedField = "hour(%0)"
With .Items
.AddItem(#1/11/2001 10:00:00 AM#)
.AddItem(#2/22/2002 11:00:00 AM#)
.AddItem(#3/13/2003 0:00:00 PM#)
.AddItem(#4/14/2004 1:00:00 PM#)
End With
End With
|
4
|
How can I change/rename the column's name

With AxComboBox1
.Columns.Add("ColumnName").Caption = "NewName"
End With
|
134
|
How can I change the width of the columns being displayed in the sort bar

With AxComboBox1
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
|
510
|
How can I change the visual appearance of the filter bar's close button (solid)

With AxComboBox1
.BeginUpdate()
.Columns.Add("Item").DisplayFilterButton = True
With .Columns.Add("Pos")
.AllowSizing = False
.AllowSort = False
.Width = 32
.FormatColumn = "1 apos ``"
.Position = 0
End With
With .Items
.AddItem("Item A")
.AddItem("Item B")
.AddItem("Item C")
End With
.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton,255)
.EndUpdate()
End With
|
511
|
How can I change the visual appearance of the filter bar's close button (EBN)

With AxComboBox1
.BeginUpdate()
With .VisualAppearance
.Add(1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" & _
"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" & _
"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" & _
"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" & _
"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" & _
"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" & _
"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" & _
"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" & _
"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" & _
"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" & _
"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ")
End With
.Columns.Add("Item").DisplayFilterButton = True
With .Columns.Add("Pos")
.AllowSizing = False
.AllowSort = False
.Width = 32
.FormatColumn = "1 apos ``"
.Position = 0
End With
With .Items
.AddItem("Item A")
.AddItem("Item B")
.AddItem("Item C")
End With
.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarToggle Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton,16777216)
.EndUpdate()
End With
|
131
|
How can I change the visual appearance of the control's sort bar, using EBN files

With AxComboBox1
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.SortBarVisible = True
.GetOcx().BackColorSortBar = &H1000000
.GetOcx().BackColorSortBarCaption = &H2000000
.Appearance = EXCOMBOBOXLib.AppearanceEnum.None2
End With
|
499
|
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)

Dim h
With AxComboBox1
.BeginUpdate()
With .VisualAppearance
.Add(3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=")
.Add(1,"CP:3 -2 -2 2 2")
.Add(4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=")
.Add(2,"CP:4 -2 -2 2 2")
End With
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.HasButtons = EXCOMBOBOXLib.ExpandButtonEnum.exCustom
.set_HasButtonsCustom(False,16777216)
.set_HasButtonsCustom(True,33554432)
.Columns.Add("Column")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,Nothing,"Child 1")
.InsertItem(h,Nothing,"Child 2")
.ExpandItem(h) = True
h = .AddItem("Root 2")
.InsertItem(h,Nothing,"Child")
End With
.EndUpdate()
End With
|
498
|
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)

Dim h
With AxComboBox1
.BeginUpdate()
With .VisualAppearance
.Add(1,"XP:TREEVIEW 2 1")
.Add(2,"XP:TREEVIEW 2 2")
End With
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,16777216)
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,33554432)
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Column")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,Nothing,"Child 1")
.InsertItem(h,Nothing,"Child 2")
.ExpandItem(h) = True
h = .AddItem("Root 2")
.InsertItem(h,Nothing,"Child")
End With
.EndUpdate()
End With
|
496
|
How can I change the visual appearance of the +/- buttons (method 1)

Dim h
With AxComboBox1
.BeginUpdate()
With .VisualAppearance
.Add(1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=")
.Add(2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=")
End With
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,16777216)
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,33554432)
.Columns.Add("Column")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,Nothing,"Child 1")
.InsertItem(h,Nothing,"Child 2")
.ExpandItem(h) = True
h = .AddItem("Root 2")
.InsertItem(h,Nothing,"Child")
End With
.EndUpdate()
End With
|
275
|
How can I change the state of a radio button

Dim h
With AxComboBox1
.MarkSearchColumn = False
.SelBackColor = RGB(255,255,128)
.SelForeColor = RGB(0,0,0)
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Radio 1"
.CellHasRadioButton(h,1) = True
.CellRadioGroup(h,1) = 1234
.CellCaption(h,2) = "Radio 2"
.CellHasRadioButton(h,2) = True
.CellRadioGroup(h,2) = 1234
.CellState(h,1) = 1
End With
End With
|
273
|
How can I change the state of a checkbox

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Check Box"
.CellHasCheckBox(h,1) = True
.CellState(h,1) = 1
End With
End With
|
132
|
How can I change the sort bar's foreground color

With AxComboBox1
.SortBarVisible = True
.ForeColorSortBar = RGB(255,0,0)
End With
|
130
|
How can I change the sort bar's background color

With AxComboBox1
.SortBarVisible = True
.BackColorSortBar = RGB(255,0,0)
.BackColorSortBarCaption = RGB(128,0,0)
End With
|
289
|
How can I change the size ( width, height ) of the picture

Dim h
With AxComboBox1
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
.CellPictureWidth(h,0) = 24
.CellPictureHeight(h,0) = 24
.ItemHeight(h) = 32
h = .AddItem("Root 2")
.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
.ItemHeight(h) = 48
End With
End With
|
32
|
How can I change the position of the column

With AxComboBox1
.Columns.Add("Column 1")
.Columns.Add("Column 2").Position = 0
End With
|
298
|
How can I change the position of an item

With AxComboBox1
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.ItemPosition(.AddItem("Item 3")) = 0
End With
End With
|
202
|
How can I change the order or the position of the columns in the sort bar

With AxComboBox1
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
.Columns.Item("C2").SortPosition = 0
End With
|
48
|
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.DisplayFilterDate = True
End With
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarDateWeekDays,"Du Lu Ma Mi Jo Vi Si")
.ApplyFilter()
End With
|
47
|
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.DisplayFilterDate = True
End With
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarDateMonths,"Janvier F vrier Mars Avril Mai Juin Juillet Ao t Septembre Octobre Novembre D cembre")
.ApplyFilter()
End With
|
133
|
How can I change the height of the sort bar's

With AxComboBox1
.SortBarVisible = True
.SortBarHeight = 48
End With
|
252
|
How can I change the height for all items

With AxComboBox1
.DefaultItemHeight = 32
.Columns.Add("Column")
.Items.AddItem("One")
.Items.AddItem("Two")
End With
|
124
|
How can I change the header's background color, when multiple levels are displayed

With AxComboBox1
.BackColorLevelHeader = RGB(250,0,0)
.Columns.Add("S").Width = 32
.Columns.Add("Level 1").LevelKey = 1
.Columns.Add("Level 2").LevelKey = 1
.Columns.Add("Level 3").LevelKey = 1
End With
|
344
|
How can I change the foreground color for edit controls

Dim h
With AxComboBox1
.ForeColorEdit = RGB(255,0,0)
.IntegralHeight = True
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.CellCaption(h,1) = "Root 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
.ExpandItem(h) = True
h = .AddItem("Root 2.1")
.CellCaption(h,1) = "Root 2.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
End With
.set_Select(0,"Root 1.1")
End With
|
215
|
How can I change the foreground color for all cells in the column

Dim var_ConditionalFormat
With AxComboBox1
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.ForeColor = RGB(255,0,0)
.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
424
|
How can I change the foreground color for a particular column

With AxComboBox1
With .Columns
.Add("Column 1")
.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderForeColor) = 8439039
.Add("Column 3")
End With
End With
|
300
|
How can I change the font for entire item
Dim f
With AxComboBox1
.Columns.Add("Default")
.Items.AddItem("default font")
f = CreateObject("StdFont")
With f
.Name = "Tahoma"
.Size = 12
End With
With .Items
.ItemFont(.AddItem("new font")) = f
End With
End With
|
217
|
How can I change the font for all cells in the entire column

Dim f
With AxComboBox1
f = CreateObject("StdFont")
With f
.Name = "Tahoma"
.Size = 12
End With
With .ConditionalFormats.Add("1")
.Font = f
.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
302
|
How can I change the font for a cell

With AxComboBox1
.Columns.Add("Default")
.Items.AddItem("std font")
With .Items
.CellCaptionFormat(.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
End With
End With
|
301
|
How can I change the font for a cell

Dim f
With AxComboBox1
.Columns.Add("Default")
.Items.AddItem("default font")
f = CreateObject("StdFont")
With f
.Name = "Tahoma"
.Size = 12
End With
With .Items
.CellFont(.AddItem("new font"),0) = f
End With
End With
|
129
|
How can I change the default caption being displayed in the control's sort bar

With AxComboBox1
.SortBarVisible = True
.SortBarCaption = "new caption"
End With
|
95
|
How can I change the control's font

With AxComboBox1
.Font.Name = "Tahoma"
.Columns.Add("Column")
End With
|
13
|
How can I change the column's width

With AxComboBox1
.ColumnAutoResize = False
.Columns.Add("Column 1").Width = 64
.Columns.Add("Column 2").Width = 128
End With
|
455
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

With AxComboBox1
.BeginUpdate()
.MarkSearchColumn = False
With .ConditionalFormats.Add("1")
.Bold = True
.ForeColor = RGB(255,0,0)
.ApplyTo = &H1
End With
.Columns.Add("C1")
With .Columns.Add("C2")
.HeaderBold = True
.HTMLCaption = "<fgcolor=FF0000>C2"
End With
With .Items
.CellCaption(.AddItem(10),1) = 11
.CellCaption(.AddItem(12),1) = 13
End With
.EndUpdate()
End With
|
314
|
How can I change the color for separator / dividers items

Dim h
With AxComboBox1
.MarkSearchColumn = False
.TreeColumnIndex = -1
.ScrollBySingleLine = False
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
h = .AddItem()
.ItemDivider(h) = 0
.ItemDividerLine(h) = EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine
.ItemDividerLineAlignment(h) = EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter
.ItemHeight(h) = 6
.SelectableItem(h) = False
h = .AddItem("Cell 2")
.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
End With
End With
|
359
|
How can I change the background color or the visual appearance using ebn for a particular column

With AxComboBox1
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
With .Columns
.Add("Column 1")
.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 16777216
.Add("Column 3").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 16777471
.Add("Column 4")
End With
End With
|
407
|
How can I change the background color for the filter field in the bottom part of the drop down portion

With AxComboBox1
.BeginUpdate()
.FilterForVisible = True
.FilterForBackColor = RGB(240,240,240)
.IntegralHeight = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
.EndUpdate()
End With
|
343
|
How can I change the background color for edit controls

Dim h
With AxComboBox1
.BackColorEdit = RGB(255,0,0)
.IntegralHeight = True
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.CellCaption(h,1) = "Root 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
.CellCaption(.InsertItem(h,Nothing,"Child 2.1"),1) = "Child 2.2"
.ExpandItem(h) = True
h = .AddItem("Root 2.1")
.CellCaption(h,1) = "Root 2.2"
.CellCaption(.InsertItem(h,Nothing,"Child 1.1"),1) = "Child 1.2"
End With
.set_Select(0,"Root 1.1")
End With
|
216
|
How can I change the background color for all cells in the column

Dim var_ConditionalFormat
With AxComboBox1
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.BackColor = RGB(255,0,0)
.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
358
|
How can I change the background color for a particular column

With AxComboBox1
With .Columns
.Add("Column 1")
.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 8439039
.Add("Column 3")
End With
End With
|
423
|
How can I change the background color for a particular column

With AxComboBox1
With .Columns
.Add("Column 1")
.Add("Column 2").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor) = 8439039
.Add("Column 3")
End With
End With
|
408
|
How can I change the background appearance (ebn) for the filter field in the bottom part of the drop down portion

With AxComboBox1
.BeginUpdate()
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.FilterForVisible = True
.GetOcx().FilterForBackColor = &H1000000
.IntegralHeight = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
.EndUpdate()
End With
|
50
|
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
.Filter = 0
End With
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarIsChecked,"Check_On")
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarIsUnchecked,"Check_Off")
.ApplyFilter()
End With
|
35
|
How can I change the "Filter For" caption in the column's drop down filter window

With AxComboBox1
.Columns.Add("Column").DisplayFilterButton = True
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"new caption")
End With
|
49
|
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
End With
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarChecked,"with check on")
.set_Description(EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarUnchecked,"with check off")
End With
|
231
|
How can I change at runtime the parent of the item

Dim hC,hP
With AxComboBox1
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Default")
With .Items
hP = .AddItem("Root")
hC = .AddItem("Child")
.SetParent(hC,hP)
End With
End With
|
57
|
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
61
|
How can I can I programmatically filter the checked items

With AxComboBox1
With .Columns.Add("Column")
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
.Filter = 0
End With
.Items.AddItem(0)
With .Items
.CellState(.AddItem(1),0) = 1
End With
.Items.AddItem(2)
.ApplyFilter()
End With
|
62
|
How can I can I programmatically filter for items with a specified icon assigned

With AxComboBox1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exImage
.Filter = 1
End With
With .Items
.CellImage(.AddItem("Image 1"),0) = 1
.CellImage(.AddItem("Image 1"),0) = 1
.CellImage(.AddItem("Image 2"),0) = 2
.CellImage(.AddItem("Image 3"),0) = 3
End With
.ApplyFilter()
End With
|
60
|
How can I can I filter programmatically the items based on some numerichal rules

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exNumeric
.Filter = "> 0 <= 1"
End With
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
.ApplyFilter()
End With
|
59
|
How can I can I filter programmatically the items based on a range/interval of dates

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.DisplayFilterDate = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exDate
.Filter = "1/1/2001 to 1/1/2002"
End With
.Items.AddItem("1/1/2001")
.Items.AddItem("2/1/2002")
.ApplyFilter()
End With
|
58
|
How can I can I filter programmatically given a specified pattern using wild characters like * or

With AxComboBox1
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exPattern
.Filter = "0*"
End With
.Items.AddItem(0)
.Items.AddItem("00")
.Items.AddItem(1)
.Items.AddItem("11")
.ApplyFilter()
End With
|
555
|
How can I build a "virtual" tree using your control

' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
Private Sub AxComboBox1_BeforeExpandItem(ByVal sender As System.Object, ByVal e As AxEXCOMBOBOXLib._IComboBoxEvents_BeforeExpandItemEvent) Handles AxComboBox1.BeforeExpandItem
With AxComboBox1
With .Items
.ItemHasChildren(.InsertItem(e.item,Nothing,"new")) = True
End With
End With
End Sub
With AxComboBox1
.BeginUpdate()
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Style = EXCOMBOBOXLib.StyleEnum.DropDown
.Columns.Add("Def")
With .Items
.AddItem("Item 1")
.ItemHasChildren(.AddItem("Item 2")) = True
.AddItem("Item 3")
End With
.Value = "Item 2"
.EndUpdate()
End With
|
363
|
How can I bold the items that contains data or those who displays empty strings

Dim h,hC
With AxComboBox1
.ConditionalFormats.Add("not len(%1)=0").Bold = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Root")
.InsertItem(h,Nothing,"Child 1")
hC = .InsertItem(h,Nothing,"Child 2")
.CellCaption(hC,1) = "1"
.InsertItem(h,Nothing,"Child 3")
.ExpandItem(h) = True
End With
End With
|
211
|
How can I bold the entire column

Dim var_ConditionalFormat
With AxComboBox1
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.Bold = True
.ApplyTo = EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
25
|
How can I bold only a portion of the column's header

With AxComboBox1
.Columns.Add("Column 1").HTMLCaption = "<b>Col</b>umn 1"
End With
|
269
|
How can I associate an extra data to a cell

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Cell 2"
.CellData(h,1) = "your extra data"
End With
End With
|
280
|
How can I assign multiple icons/pictures to a cell

Dim h
With AxComboBox1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root <img>1</img> 1, <img>2</img>, ... and so on ")
.CellCaptionFormat(h,0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
End With
End With
|
279
|
How can I assign multiple icons/pictures to a cell

Dim h
With AxComboBox1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.CellImages(h,0) = "1,2,3"
End With
End With
|
282
|
How can I assign multiple icon/picture to a cell

Dim h
With AxComboBox1
.set_HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
.set_HTMLPicture("p2","c:\exontrol\images\auction.gif")
.Columns.Add("Default")
With .Items
h = .AddItem("text <img>p1</img> another picture <img>p2</img> and so on")
.CellCaptionFormat(h,0) = EXCOMBOBOXLib.CaptionFormatEnum.exHTML
.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\colorize.gif`)")
.ItemHeight(h) = 48
.AddItem("Root 2")
End With
End With
|
14
|
How can I assign checkboxes for the entire column

With AxComboBox1
.Columns.Add("Column 1").Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
End With
|
281
|
How can I assign an icon/picture to a cell

Dim h
With AxComboBox1
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.CellPicture(h,0) = AxComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
.ItemHeight(h) = 48
.AddItem("Root 2")
End With
End With
|
278
|
How can I assign an icon/picture to a cell

Dim h
With AxComboBox1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.CellImage(h,0) = 1
.CellImage(.InsertItem(h,Nothing,"Child 1"),0) = 2
.CellImage(.InsertItem(h,Nothing,"Child 2"),0) = 3
.ExpandItem(h) = True
End With
End With
|
270
|
How can I assign a tooltip to a cell

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "tooltip"
.CellToolTip(h,1) = "This is bit of text that's shown when the user hovers the cell"
End With
End With
|
274
|
How can I assign a radio button to a cell

Dim h
With AxComboBox1
.MarkSearchColumn = False
.SelBackColor = RGB(255,255,128)
.SelForeColor = RGB(0,0,0)
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Radio 1"
.CellHasRadioButton(h,1) = True
.CellRadioGroup(h,1) = 1234
.CellCaption(h,2) = "Radio 2"
.CellHasRadioButton(h,2) = True
.CellRadioGroup(h,2) = 1234
.CellState(h,1) = 1
End With
End With
|
16
|
How can I assign a different background color for the entire column

With AxComboBox1
.MarkSearchColumn = False
.Columns.Add("Column 1").Def(EXCOMBOBOXLib.DefColumnEnum.exCellBackColor) = 255
.Columns.Add("Column 2")
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
End With
|
272
|
How can I assign a checkbox to a cell

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Check Box"
.CellHasCheckBox(h,1) = True
End With
End With
|
15
|
How can I assign a check box for a cell

With AxComboBox1
.Columns.Add("Column 1")
With .Items
.AddItem(0)
.CellHasCheckBox(.AddItem(1),0) = True
.AddItem(2)
End With
End With
|
30
|
How can I apply an strikeout font only a portion of the column's header

With AxComboBox1
.Columns.Add("Column 1").HTMLCaption = "<s>Col</s>umn 1"
End With
|
27
|
How can I apply an italic font only a portion of the column's header

With AxComboBox1
.Columns.Add("Column 1").HTMLCaption = "<i>Col</i>umn 1"
End With
|
353
|
How can I align the text/caption on the scroll bar

With AxComboBox1
.set_ScrollPartCaption(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,"left")
.set_ScrollPartCaptionAlignment(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,EXCOMBOBOXLib.AlignmentEnum.LeftAlignment)
.set_ScrollPartCaption(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,"right")
.set_ScrollPartCaptionAlignment(EXCOMBOBOXLib.ScrollBarEnum.exHScroll,EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
.ColumnAutoResize = False
.Columns.Add(1)
.Columns.Add(2)
.Columns.Add(3)
.Columns.Add(4)
.Columns.Add(5)
.Columns.Add(6)
End With
|
183
|
How can I align the icon in the column's header in the center

With AxComboBox1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
With .Columns.Add("")
.HeaderImage = 1
.HeaderImageAlignment = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
End With
End With
|
177
|
How can I align the column to the right, and its caption too

With AxComboBox1
With .Columns.Add("Column")
.Alignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.HeaderAlignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
176
|
How can I align the column to the right

With AxComboBox1
.Columns.Add("Column").Alignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
304
|
How can I align the cell to the left, center or to the right

With AxComboBox1
.TreeColumnIndex = -1
.DrawGridLines = EXCOMBOBOXLib.GridLinesEnum.exRowLines
.Columns.Add("Default")
With .Items
.CellHAlignment(.AddItem("left"),0) = EXCOMBOBOXLib.AlignmentEnum.LeftAlignment
.CellHAlignment(.AddItem("center"),0) = EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
.CellHAlignment(.AddItem("right"),0) = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
End With
|
135
|
How can I add several columns to control's sort bar

With AxComboBox1
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
|
313
|
How can I add separator - dividers items

Dim h
With AxComboBox1
.MarkSearchColumn = False
.TreeColumnIndex = -1
.ScrollBySingleLine = False
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
h = .AddItem()
.ItemDivider(h) = 0
.ItemDividerLine(h) = EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine
.ItemDividerLineAlignment(h) = EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter
.ItemHeight(h) = 6
.SelectableItem(h) = False
h = .AddItem("Cell 2")
.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
.CellSingleLine(h,1) = EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap
End With
End With
|
226
|
How can I add or insert child items

Dim h
With AxComboBox1
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.CellCaption(h,1) = "Cell 2"
.CellCaption(.InsertItem(h,Nothing,"Cell 3"),1) = "Cell 4"
.CellCaption(.InsertItem(h,Nothing,"Cell 5"),1) = "Cell 6"
.ExpandItem(h) = True
End With
End With
|
223
|
How can I add or insert an item

With AxComboBox1
.Columns.Add("Default")
.Items.AddItem("new item")
End With
|
224
|
How can I add or insert an item

Dim h
With AxComboBox1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
.CellCaption(.AddItem("Cell 1"),1) = "Cell 2"
h = .AddItem("Cell 3")
.CellCaption(h,1) = "Cell 4"
End With
End With
|
225
|
How can I add or insert a child item

With AxComboBox1
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Default")
With .Items
.InsertItem(.AddItem("root"),Nothing,"child")
End With
End With
|
464
|
How can I add or change the padding (spaces) for captions in the control's header

With AxComboBox1
.BeginUpdate()
.Columns.Add("Padding-Left").Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingLeft) = 18
With .Columns.Add("Padding-Right")
.Def(EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingRight) = 18
.HeaderAlignment = EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
.EndUpdate()
End With
|
3
|
How can I add multiple columns

With AxComboBox1
With .Columns
.Add("Column 1")
.Add("Column 2")
End With
End With
|
465
|
How can I add a vertical padding

With AxComboBox1
.BeginUpdate()
.DrawGridLines = EXCOMBOBOXLib.GridLinesEnum.exAllLines
With .Columns.Add("Padding")
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine) = False
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingLeft) = 6
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingRight) = 6
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingTop) = 6
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellPaddingBottom) = 6
End With
With .Items
.AddItem("padding")
.AddItem("padding")
End With
.EndUpdate()
End With
|
1
|
How can I add a new column

With AxComboBox1
.Columns.Add("ColumnName")
End With
|
454
|
How can I add a horizontal scroll bar

With AxComboBox1
.BeginUpdate()
.ScrollBySingleLine = True
.ColumnAutoResize = False
.BackColorAlternate = RGB(240,240,240)
With .Columns.Add("Default")
.Width = 512
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine) = False
End With
With .Items
.AddItem("Exontrol is devoted to create innovative user interface components for Windows applications, on COM or .NET platforms, since 19" & _
"99. ""eXontrol"" comes from e(s)pecial (c)ontrol, where sc makes the X. We are a vendor not a reseller, and this is the single s" & _
"ite where you can try or buy our products. If you are tired of looking for ""powerful"" components now it's time to show you rea" & _
"l components. No registration required, no nag screens, no limitations, unlimited evaluation time.")
.AddItem("A combo box is a commonly-used GUI tool. It is a combination of a drop-down list or list box and a single-line textbox, allowin" & _
"g the user either to type a value directly into the control or choose from the list of existing options.")
End With
.EndUpdate()
End With
|
221
|
How can I access the properties of a column

With AxComboBox1
.Columns.Add("A")
.Columns.Item("A").HeaderBold = True
End With
|
595
|
Highlight the parent items

Dim h,hR
With AxComboBox1
.BeginUpdate()
.ConditionalFormats.Add("%CC0").ForeColor = RGB(255,0,0)
.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
.HeaderHeight = 24
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
With .Columns
.Add("Item").Width = 16
.Add("Desc")
End With
With .Items
hR = .AddItem("Root")
.CellCaption(hR,1) = "The root directory /"
h = .InsertItem(hR,Nothing,"Home")
.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
.InsertItem(h,Nothing,"Alice")
.InsertItem(h,Nothing,"Bob")
.ExpandItem(h) = True
h = .InsertItem(hR,Nothing,"Etc")
.CellCaption(h,1) = "The etc directory with one configuration file"
h = .InsertItem(h,Nothing,"nginx.conf")
.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
.ExpandItem(hR) = True
End With
.EndUpdate()
End With
|
596
|
Highlight the leaf items

Dim h,hR
With AxComboBox1
.BeginUpdate()
.ConditionalFormats.Add("%CC0=0").ForeColor = RGB(128,128,128)
.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
.HeaderHeight = 24
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
With .Columns
.Add("Item").Width = 16
.Add("Desc")
End With
With .Items
hR = .AddItem("Root")
.CellCaption(hR,1) = "The root directory /"
h = .InsertItem(hR,Nothing,"Home")
.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
.InsertItem(h,Nothing,"Alice")
.InsertItem(h,Nothing,"Bob")
.ExpandItem(h) = True
h = .InsertItem(hR,Nothing,"Etc")
.CellCaption(h,1) = "The etc directory with one configuration file"
h = .InsertItem(h,Nothing,"nginx.conf")
.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
.ExpandItem(hR) = True
End With
.EndUpdate()
End With
|
594
|
Highlight the item being expanded or collapsed

Dim h,hR
With AxComboBox1
.BeginUpdate()
.ConditionalFormats.Add("%CX0").Bold = True
.HeaderAppearance = EXCOMBOBOXLib.AppearanceEnum.Etched
.HeaderHeight = 24
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
With .Columns
.Add("Item").Width = 16
.Add("Desc")
End With
With .Items
hR = .AddItem("Root")
.CellCaption(hR,1) = "The root directory /"
h = .InsertItem(hR,Nothing,"Home")
.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
.InsertItem(h,Nothing,"Alice")
.InsertItem(h,Nothing,"Bob")
.ExpandItem(h) = True
h = .InsertItem(hR,Nothing,"Etc")
.CellCaption(h,1) = "The etc directory with one configuration file"
h = .InsertItem(h,Nothing,"nginx.conf")
.CellCaption(.InsertItem(hR,Nothing,"Var"),1) = "The var directory"
.ExpandItem(hR) = True
End With
.EndUpdate()
End With
|
589
|
Force hover-all feature
With AxComboBox1
.set_Background(EXCOMBOBOXLib.BackgroundPartEnum.exScrollHoverAll,-1)
End With
|
515
|
FilterBarCaption Predefined Keywords

' AfterExpandItem event - Fired after an item is expanded (collapsed).
Private Sub AxComboBox1_AfterExpandItem(ByVal sender As System.Object, ByVal e As AxEXCOMBOBOXLib._IComboBoxEvents_AfterExpandItemEvent) Handles AxComboBox1.AfterExpandItem
With AxComboBox1
.Refresh()
End With
End Sub
Dim h
With AxComboBox1
.BeginUpdate()
.LinesAtRoot = EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Item").DisplayFilterButton = True
With .Columns.Add("Check")
.Def(EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox) = True
.DisplayFilterButton = True
.DisplayFilterPattern = False
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exCheck
End With
With .Columns.Add("Pos")
.AllowSizing = False
.AllowSort = False
.Width = 32
.FormatColumn = "1 apos ``"
.Position = 0
End With
With .Items
.AddItem("Item A")
h = .AddItem("Item B")
.CellState(.InsertItem(h,Nothing,"Sub-Item B1"),1) = 1
.InsertItem(h,Nothing,"Sub-Item B2")
.ExpandItem(h) = True
.AddItem("Item C")
End With
.FilterInclude = EXCOMBOBOXLib.FilterIncludeEnum.exItemsWithChilds
.FilterBarFont = .Font
.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" & _
"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" & _
": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" & _
"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" & _
"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" & _
"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" & _
" `</fgcolor>`"
.FilterBarPromptPattern = "B"
.FilterBarPromptVisible = EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible Or EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible
With .Columns.Item(0)
.FilterType = EXCOMBOBOXLib.FilterTypeEnum.exFilter
.Filter = "Item A|Item B"
End With
.ApplyFilter()
.EndUpdate()
End With
|